# 加油！杨思钦！
# 沉下心来慢慢琢磨，你是最棒的！

import openpyxl
from openpyxl import load_workbook
from config import Config


def read(filepath, sheet):
    wb = load_workbook(filepath)
    sh = wb[sheet]
    rows = list(sh.values)
    title = rows[0]
    lists = []
    for row in rows[1:]:
        temple = dict(zip(title, row))
        lists.append(temple)
    return lists


if __name__ == '__main__':
   list1= read(Config.EXCEL_PATH, "verifycode")
   print(list1)
